range in vba 在 Creating an Array from a Range in VBA - Stack Overflow 的評價 Just define the variable as a variant, and make them equal: Dim DirArray As Variant DirArray = Range("a1:a5").Value. ... <看更多>